Year End Reconciliation

This screen drives the Year End Reconciliation process and produces multiple reports used for balancing Year End. These reports enable the balancing of employee data (i.e. Year To Date values) before the Year End Finalisation process is run. This allows you to reconcile existing reports, based on the selection criteria, fix any issues detected and balance figures. The report can be run as many times as necessary and at any time.

Prerequisite

  • No Payrun can be In Progress.

Rules and Guidelines

  • This process can produce up to eight Year End Reports depending on which Payment Summary Types are in use in the database. Only the ones in use will be displayed. For the list and details of these reports, you may view the Year End Reports KB Page.
  • Up to two error reports can be produced: PAY26ERR and the PAY495ERR.

  • The reports PAY26SUM (Reconciliation Report for all Payment Summary Types), PAY12 (YTD Integrity Report), PAY009 (Employee Year to Date Figures) are used in the balancing process.

  • The PAY26FP, PAY26IP, PAY26LP, PAY2EP reports are individual payment summary reports for balancing.
  • This report can be run as many times as necessary and, at any time.
  • Position 18 of Program Control PAY26 can be used to control the printing and sorting of Payment Summaries for prior versions of employees.

Field Information

Report data for the selected Level 1 - Company code.

If left blank, all companies are included.

Report data for the selected Level 2 - State code.

If left blank, all states are included.

Report data for the selected Payrun Group.

If left blank, all Payrun Groups are included.

The Payrun Group is only editable if the user is in the blank environment. Otherwise, it will default to the Payrun Group that is associated to the Environment that you are in at the time of running this process.

Payment Summaries are printed based on the start and end date of the financial year.

  • The From date must be the 1st of July of the previous calendar year.
  • If the From date is left blank, this will default to the 1st July of the current processing year.
  • If the To date is left blank, this will default to the 30th June of the current processing year.

 

Indicate whether to included or exclude employees with zero Year-to-Date figures.

Code Description
E Exclude employees with Zero YTD figures.
I Include employees with Zero YTD figures.

 

Indicate which Pay Frequencies are included . If left blank, all Pay Frequencies are included.

Code Description
4 4 Weekly
A Half Monthly
F Fortnightly
M Monthly
W Weekly
Blank All Pay Frequencies

 

 

This section is used to specify the printing sequence of the generated report, if by Level Codes 2, 3, 4, 5, or Name.

Ticking a particular box will sequence the report by the selected Level Code/Name.

Leaving the tick box blank means that the report will not be ordered by the corresponding Level Code/Name.

 

Select Run Process.